package model.dao;

import java.sql.SQLException;
import java.util.List;

import org.springframework.orm.ibatis.support.SqlMapClientDaoSupport;

import model.vo.TestMemberVO;


public class TestDAOImpl extends SqlMapClientDaoSupport  implements TestDAO{
	public List waitpar(int page) throws SQLException{
		
		return super.getSqlMapClientTemplate().getSqlMapClient().queryForList("product.waitpar",page);
	}
	public int maxProduct() throws SQLException{
		
		int max=(Integer)super.getSqlMapClientTemplate().getSqlMapClient().queryForObject("product.maxProduct");
		return max;
	}
	@Override
	public void appcon(String deliveryNo) throws SQLException {
		
		super.getSqlMapClientTemplate().getSqlMapClient().update("product.appcon",deliveryNo);
		
	}
	@Override
	public List waitdept(int page) throws SQLException {
		return super.getSqlMapClientTemplate().getSqlMapClient().queryForList("product.waitdept",page);
		
	}
	@Override
	public int maxProductdept() throws SQLException {
		int max=(Integer)super.getSqlMapClientTemplate().getSqlMapClient().queryForObject("product.maxProductdept");
		return max;
	}
	@Override
	public void appdept(String deliveryNo) throws SQLException {
		super.getSqlMapClientTemplate().getSqlMapClient().update("product.appdept",deliveryNo);	
		
	}
	@Override
	public List completepar(int page) throws SQLException {
		return super.getSqlMapClientTemplate().getSqlMapClient().queryForList("product.completepar",page);
	}
	@Override
	public int maxProductcom() throws SQLException {
		int max=(Integer)super.getSqlMapClientTemplate().getSqlMapClient().queryForObject("product.maxProductcom");
		return max;
	}
	@Override
	public void compar(String deliveryNo) throws SQLException {
		System.out.println("compar in the sql");
		super.getSqlMapClientTemplate().getSqlMapClient().update("product.compar",deliveryNo);	
		
	}
}
